BMUG Revelations/BMUG Revelations.toast/Business/Excel/Mortgage Analyzer/AMORMENU

Excel Spreadsheet | 1993-04-23 | 14KB | 358 lines

Sheet:
(0, 2)        COMMAND NAME
(0, 3)        REFERENCE
(0, 4)        KEY
(0, 5)        STATUS MESSAGE
(0, 6)        HELP TEXT
(0, 8)        MORTVIEW
(1, 2)        Print Menu
(1, 3)
(1, 4)
(1, 5)
(1, 6)
(1, 8)        TRUE
(2, 0)        macros for mortgage main menu
(2, 2)        Print Summary
(2, 3)        prtsumdata
(2, 5)        Prints summary of inputed information and resulting data
(2, 6)
(2, 8)        FALSE
(3, 2)        Print Original Amorization Table
(3, 3)        prtamo
(3, 5)        Prints Amoritization Schedule
(3, 6)
(3, 8)        TRUE
(4, 0)
(4, 2)        Print Additional Payment Table
(4, 3)        prtamextpmt
(4, 5)        Prints amoritization schedule as affected by additional payments
(4, 6)
(4, 8)        TRUE
(5, 0)        DELETESPECMENU
(5, 1)        used as auto close macro to remove menu in the 9 slot
(5, 2)        Print Refinancing Table
(5, 3)        prtamrefin
(5, 5)        Prints amoritization schedule as affected by rerfinancing
(5, 6)
(5, 8)
(6, 0)        TRUE
(6, 1)        can use same macro for various menus because they are located in the same space
(6, 2)
(6, 3)
(6, 4)
(6, 5)
(6, 6)
(6, 8)
(7, 0)        TRUE
(7, 1)
(8, 1)
(8, 8)
(9, 0)
(9, 2)        Mortgage Analysis Options
(9, 3)
(10, 0)
(10, 1)        OPTION-COMMAND-a
(10, 2)        Mortgage Manipulator
(10, 3)        opmm
(10, 5)        Opens Mortgage Manipulator
(10, 6)
(10, 8)
(11, 1)
(11, 2)        Rate and Term Analyzer
(11, 3)        opra
(11, 5)        Opens Rate and Term Analyzer
(11, 6)
(11, 8)
(12, 0)        ADD FORMAT
(12, 1)
(12, 2)        Variable Rate Analyzer
(12, 3)        opva
(12, 5)        Opens Variable Rate Analyzer
(12, 6)
(12, 8)
(13, 0)        20
(13, 1)
(13, 6)
(13, 8)
(14, 0)        TRUE
(14, 1)
(14, 8)
(15, 1)
(15, 8)
(16, 0)        prtsumdata
(16, 8)
(17, 0)        TRUE
(17, 1)        Do not need to use add format
(17, 8)
(18, 0)        TRUE
(18, 1)        macro if adding menu
(18, 8)
(19, 0)        FALSE
(19, 8)
(20, 0)        TRUE
(20, 8)
(21, 0)        TRUE
(21, 1)        OPTION-COMMAND-m
(21, 8)
(22, 8)
(23, 0)        ADDSPECMENU
(23, 1)
(23, 8)
(24, 0)        9
(24, 8)
(25, 0)        TRUE
(25, 1)
(25, 8)
(26, 0)        TRUE
(26, 1)
(26, 8)
(27, 0)        TRUE
(27, 1)
(27, 8)
(28, 1)
(28, 8)
(29, 1)
(29, 8)
(30, 0)        prtamo
(30, 1)
(30, 8)
(31, 0)        TRUE
(31, 8)
(32, 0)        TRUE
(32, 1)
(32, 8)
(33, 0)        FALSE
(33, 1)
(33, 8)
(34, 0)        TRUE
(34, 1)
(34, 8)
(35, 0)        TRUE
(35, 1)
(35, 8)
(36, 1)
(36, 8)
(37, 1)
(37, 8)
(38, 8)
(39, 8)
(40, 8)
(41, 0)        prtamextpmt
(41, 8)
(42, 0)        TRUE
(42, 8)
(43, 0)        TRUE
(43, 8)
(44, 0)        FALSE
(44, 8)
(45, 0)        FALSE
(45, 8)
(46, 0)        TRUE
(46, 8)
(47, 8)
(48, 8)
(49, 8)
(50, 8)
(51, 8)
(52, 0)        prtamrefin
(52, 8)
(53, 0)        TRUE
(53, 8)
(54, 0)        TRUE
(54, 8)
(55, 0)        FALSE
(55, 8)
(56, 0)        TRUE
(56, 8)
(57, 0)        TRUE
(57, 8)
(58, 8)
(59, 8)
(60, 0)        macros for main menu
(60, 1)        OPTION-COMMAND-j
(60, 8)
(61, 2)
(61, 8)
(62, 0)        ADDMAINMENU
(62, 2)
(62, 8)
(63, 0)        TRUE
(63, 2)
(63, 8)
(64, 0)        9
(64, 2)
(65, 0)        TRUE
(65, 2)
(66, 0)
(66, 2)
(67, 0)
(67, 2)
(68, 0)
(68, 2)
(69, 0)
(69, 2)
(70, 2)
(73, 2)
(73, 3)
(74, 2)
(74, 3)
(75, 0)        opmm
(75, 1)        Deletes "mortgae analysis menu",second argument must be adjusted to refeclt size of menu
(75, 2)
(75, 3)
(76, 0)        TRUE
(76, 1)        adds mm print menu
(76, 2)
(77, 0)        TRUE
(77, 2)
(78, 0)        TRUE
(78, 1)        RUNS macro beginning in this cell
(79, 0)        TRUE
(80, 0)        #N/A!
(81, 0)        TRUE
(86, 0)        opra
(87, 0)        TRUE
(88, 0)        TRUE
(89, 0)        TRUE
(90, 0)        TRUE
(91, 0)        #N/A!
(92, 0)        TRUE
(95, 0)        opva
(96, 0)        open(" ")
(97, 0)        FALSE
(99, 0)
(100, 0)
(101, 0)
(102, 0)
(103, 0)
(104, 0)
(105, 0)
(106, 0)
(107, 0)
(108, 0)
(109, 0)
(110, 0)
(111, 0)        Macros for rate term analyzer
(111, 1)
(111, 2)        COMMAND NAME
(111, 3)        REFERENCE
(111, 4)        KEY
(111, 5)        STATUS MESSAGE
(111, 6)        HELP TEXT
(112, 0)
(112, 1)
(112, 2)        Print Menu
(112, 3)
(112, 4)
(112, 5)
(112, 6)
(113, 0)
(113, 1)
(113, 2)        Original and Alt Rate Only
(113, 3)        prtratealtrate
(113, 5)        Prints Original and Alternative Rate Tables
(113, 6)
(114, 0)        prtmaster
(114, 1)
(114, 2)        Original and Alt Term Only
(114, 3)        prtrateterm
(114, 5)        Prints Original and Alternative Term Tables
(114, 6)
(115, 0)        TRUE
(115, 1)
(115, 2)        Original and Alt Rate/Term Only
(115, 3)        prtart
(115, 5)        Prints Original and Alternative Rate/Term Only
(116, 0)        TRUE
(116, 2)        Master Comparision
(116, 3)        prtmaster
(116, 5)        Prints all tables
(117, 0)        FALSE
(117, 2)        Summary
(117, 3)        prtsummary
(117, 5)        Prints Summary including tax deduction analysis
(118, 0)        TRUE
(118, 2)
(119, 0)        TRUE
(120, 0)
(121, 0)
(122, 0)        prtratealtrate
(123, 0)        TRUE
(124, 0)        TRUE
(125, 0)        FALSE
(126, 0)        TRUE
(127, 0)        TRUE
(128, 0)
(130, 0)        prtrateterm
(131, 0)        TRUE
(132, 0)        TRUE
(133, 0)        TRUE
(134, 0)        FALSE
(135, 0)        TRUE
(138, 0)        prtsummary
(139, 0)        FALSE
(140, 0)        TRUE
(141, 0)        FALSE
(142, 0)        TRUE
(143, 0)        TRUE
(146, 0)        AddrtaMENU
(146, 1)        auto open
(147, 0)        10
(148, 0)        TRUE
(150, 0)        prtart
(151, 0)        TRUE
(152, 0)        TRUE
(153, 0)        FALSE
(154, 0)        TRUE
(155, 0)        TRUE
(166, 0)        Macros for Variable Rate Worksheet
(167, 2)        COMMAND NAME
(167, 3)        REFERENCE
(167, 4)        KEY
(167, 5)        STATUS MESSAGE
(167, 6)        HELP TEXT
(168, 0)        Prtvrm
(168, 2)        Print Menu
(168, 3)
(168, 4)
(168, 5)
(168, 6)
(169, 0)        FALSE
(169, 2)        Print Comparison
(169, 3)        Prtvrm
(169, 5)        Prints Variable and Fixed Rate Tables
(169, 6)
(170, 0)        TRUE
(171, 0)        FALSE
(172, 0)        TRUE
(173, 0)        TRUE
(176, 0)        AddvrmMENU
(176, 1)        auto open
(177, 0)        10
(178, 0)        TRUE
(184, 0)        Macros for Flexible Analyzer
(185, 2)        COMMAND NAME
(185, 3)        REFERENCE
(185, 4)        KEY
(185, 5)        STATUS MESSAGE
(185, 6)        HELP TEXT
(186, 0)        Prtflex
(186, 2)        Print Menu
(186, 3)
(186, 4)
(186, 5)
(186, 6)
(187, 0)        TRUE
(187, 2)        Print Comparison
(187, 3)        Prtflex
(187, 5)        Prints Original and Modified Tables
(187, 6)
(188, 0)        TRUE
(189, 0)        FALSE
(190, 0)        FALSE
(191, 0)        TRUE
(193, 0)        AddflexMENU
(193, 1)        auto open
(194, 0)        9
(195, 0)        TRUE